ds=$1

mysql -e "truncate business.bigdata01_ads_t_mp_open_id;"-ubusiness -pBusiness45345..


sqoop export \
--export-dir /daas/motl/bigdata01/dws/dws_t_mp_open_id/ds=${ds} \
--columns subCount,unsubCount \
--fields-terminated-by ',' \
--connect 'jdbc:mysql://cdh01:3306/business?useUnicode=true&characterEncoding=UTF-8&useSSL=false' \
--username business \
--password Business45345.. \
--table bigdata01_ads_t_mp_open_id \
--num-mappers 1